Dataset statistics
| Number of variables | 17 |
|---|---|
| Number of observations | 4154739 |
| Missing cells | 13024555 |
| Missing cells (%) | 18.4% |
| Duplicate rows | 13752 |
| Duplicate rows (%) | 0.3% |
| Total size in memory | 2.0 GiB |
| Average record size in memory | 517.0 B |
Variable types
| Numeric | 7 |
|---|---|
| DateTime | 2 |
| Unsupported | 2 |
| Text | 3 |
| Categorical | 3 |
| Dataset has 13752 (0.3%) duplicate rows | Duplicates |
start_time has 1092248 (26.3%) missing values | Missing |
stop_time has 1092248 (26.3%) missing values | Missing |
bike_id has 2483972 (59.8%) missing values | Missing |
birth_year has 2524704 (60.8%) missing values | Missing |
gender has 2483972 (59.8%) missing values | Missing |
ride_id has 1670767 (40.2%) missing values | Missing |
rideable_type has 1670767 (40.2%) missing values | Missing |
start_station_id is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
end_station_id is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Reproduction
| Analysis started | 2024-01-21 20:14:47.599019 |
|---|---|
| Analysis finished | 2024-01-21 20:18:15.390988 |
| Duration | 3 minutes and 27.79 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
trip_duration
Real number (ℝ)
| Distinct | 5271 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 625.74895 |
| Minimum | 1 |
|---|---|
| Maximum | 5271 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 63.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 127 |
| Q1 | 254 |
| median | 404 |
| Q3 | 693 |
| 95-th percentile | 2005 |
| Maximum | 5271 |
| Range | 5270 |
| Interquartile range (IQR) | 439 |
Descriptive statistics
| Standard deviation | 678.04054 |
|---|---|
| Coefficient of variation (CV) | 1.0835664 |
| Kurtosis | 11.592739 |
| Mean | 625.74895 |
| Median Absolute Deviation (MAD) | 183 |
| Skewness | 3.0543369 |
| Sum | 2.5998236 × 109 |
| Variance | 459738.98 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 248 | 8236 | 0.2% |
| 252 | 8224 | 0.2% |
| 256 | 8205 | 0.2% |
| 244 | 8200 | 0.2% |
| 253 | 8177 | 0.2% |
| 241 | 8173 | 0.2% |
| 246 | 8168 | 0.2% |
| 251 | 8155 | 0.2% |
| 249 | 8155 | 0.2% |
| 243 | 8152 | 0.2% |
| Other values (5261) | 4072894 |
| Value | Count | Frequency (%) |
| 1 | 889 | |
| 2 | 1840 | |
| 3 | 1558 | |
| 4 | 1149 | |
| 5 | 1050 | |
| 6 | 964 | |
| 7 | 1015 | |
| 8 | 950 | |
| 9 | 891 | |
| 10 | 860 |
| Value | Count | Frequency (%) |
| 5271 | 19 | |
| 5270 | 16 | |
| 5269 | 13 | |
| 5268 | 13 | |
| 5267 | 9 | |
| 5266 | 17 | |
| 5265 | 17 | |
| 5264 | 12 | |
| 5263 | 18 | |
| 5262 | 11 |
start_time
Date
MISSING 
| Distinct | 2987105 |
|---|---|
| Distinct (%) | 97.5% |
| Missing | 1092248 |
| Missing (%) | 26.3% |
| Memory size | 63.4 MiB |
| Minimum | 2015-09-21 14:53:16 |
|---|---|
| Maximum | 2023-12-31 23:59:57 |
stop_time
Date
MISSING 
| Distinct | 2989726 |
|---|---|
| Distinct (%) | 97.6% |
| Missing | 1092248 |
| Missing (%) | 26.3% |
| Memory size | 63.4 MiB |
| Minimum | 2015-09-21 14:54:17 |
|---|---|
| Maximum | 2024-01-01 00:28:15 |
start_station_id
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 87 |
|---|---|
| Missing (%) | < 0.1% |
| Memory size | 254.6 MiB |
| Distinct | 319 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 87 |
| Missing (%) | < 0.1% |
| Memory size | 324.4 MiB |
Length
| Max length | 44 |
|---|---|
| Median length | 38 |
| Mean length | 16.871595 |
| Min length | 4 |
Characters and Unicode
| Total characters | 70095604 |
|---|---|
| Distinct characters | 63 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 172 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Marin Light Rail |
|---|---|
| 2nd row | Exchange Place |
| 3rd row | Exchange Place |
| 4th row | McGinley Square |
| 5th row | Exchange Place |
| Value | Count | Frequency (%) |
| st | 2463073 | 16.7% |
| 1854592 | 12.6% | |
| ave | 491720 | 3.3% |
| park | 477837 | 3.2% |
| path | 430822 | 2.9% |
| grove | 296914 | 2.0% |
| hudson | 283686 | 1.9% |
| newport | 256467 | 1.7% |
| rail | 241798 | 1.6% |
| light | 241798 | 1.6% |
| Other values (313) | 7674110 |
Most occurring characters
| Value | Count | Frequency (%) |
| 10558167 | 15.1% | |
| t | 5061636 | 7.2% |
| r | 4169273 | 5.9% |
| a | 4148751 | 5.9% |
| e | 3767796 | 5.4% |
| o | 3566946 | 5.1% |
| n | 3556869 | 5.1% |
| S | 3066563 | 4.4% |
| i | 3035366 | 4.3% |
| l | 2436196 | 3.5% |
| Other values (53) | 26728041 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 43206494 | |
| Uppercase Letter | 12987092 | 18.5% |
| Space Separator | 10558167 | 15.1% |
| Decimal Number | 1489253 | 2.1% |
| Other Punctuation | 1330824 | 1.9% |
| Dash Punctuation | 523772 | 0.7% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 5061636 | |
| r | 4169273 | |
| a | 4148751 | |
| e | 3767796 | 8.7% |
| o | 3566946 | 8.3% |
| n | 3556869 | 8.2% |
| i | 3035366 | 7.0% |
| l | 2436196 | 5.6% |
| s | 1849751 | 4.3% |
| k | 1355919 | 3.1% |
| Other values (15) | 10257991 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 3066563 | |
| H | 1542175 | |
| P | 1471505 | |
| A | 985173 | 7.6% |
| M | 712580 | 5.5% |
| C | 689331 | 5.3% |
| T | 626203 | 4.8% |
| G | 531651 | 4.1% |
| L | 521317 | 4.0% |
| W | 503835 | 3.9% |
| Other values (13) | 2336759 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 607167 | |
| 4 | 198586 | 13.3% |
| 6 | 196254 | 13.2% |
| 2 | 127049 | 8.5% |
| 5 | 82241 | 5.5% |
| 8 | 72028 | 4.8% |
| 9 | 64147 | 4.3% |
| 7 | 60661 | 4.1% |
| 3 | 57331 | 3.8% |
| 0 | 23789 | 1.6% |
Space Separator
| Value | Count | Frequency (%) |
| 10558167 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1330824 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 523772 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 56193586 | |
| Common | 13902018 | 19.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 5061636 | 9.0% |
| r | 4169273 | 7.4% |
| a | 4148751 | 7.4% |
| e | 3767796 | 6.7% |
| o | 3566946 | 6.3% |
| n | 3556869 | 6.3% |
| S | 3066563 | 5.5% |
| i | 3035366 | 5.4% |
| l | 2436196 | 4.3% |
| s | 1849751 | 3.3% |
| Other values (38) | 21534439 |
Common
| Value | Count | Frequency (%) |
| 10558167 | ||
| & | 1330824 | 9.6% |
| 1 | 607167 | 4.4% |
| - | 523772 | 3.8% |
| 4 | 198586 | 1.4% |
| 6 | 196254 | 1.4% |
| 2 | 127049 | 0.9% |
| 5 | 82241 | 0.6% |
| 8 | 72028 | 0.5% |
| 9 | 64147 | 0.5% |
| Other values (5) | 141783 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 70095604 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 10558167 | 15.1% | |
| t | 5061636 | 7.2% |
| r | 4169273 | 5.9% |
| a | 4148751 | 5.9% |
| e | 3767796 | 5.4% |
| o | 3566946 | 5.1% |
| n | 3556869 | 5.1% |
| S | 3066563 | 4.4% |
| i | 3035366 | 4.3% |
| l | 2436196 | 3.5% |
| Other values (53) | 26728041 |
start_station_latitude
Real number (ℝ)
| Distinct | 128281 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.728069 |
| Minimum | 40.678334 |
|---|---|
| Maximum | 40.806619 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 63.4 MiB |
Quantile statistics
| Minimum | 40.678334 |
|---|---|
| 5-th percentile | 40.712774 |
| Q1 | 40.719252 |
| median | 40.725685 |
| Q3 | 40.736982 |
| 95-th percentile | 40.749985 |
| Maximum | 40.806619 |
| Range | 0.12828463 |
| Interquartile range (IQR) | 0.017730518 |
Descriptive statistics
| Standard deviation | 0.01141219 |
|---|---|
| Coefficient of variation (CV) | 0.00028020455 |
| Kurtosis | -0.65359517 |
| Mean | 40.728069 |
| Median Absolute Deviation (MAD) | 0.0079534836 |
| Skewness | 0.5754121 |
| Sum | 1.692145 × 108 |
| Variance | 0.00013023809 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.71958612 | 238391 | 5.7% |
| 40.72759597 | 142834 | 3.4% |
| 40.7272235 | 119577 | 2.9% |
| 40.7287448 | 109393 | 2.6% |
| 40.71458404 | 90710 | 2.2% |
| 40.7192517 | 79290 | 1.9% |
| 40.7177325 | 78799 | 1.9% |
| 40.7211236 | 77973 | 1.9% |
| 40.7112423 | 74476 | 1.8% |
| 40.72152515 | 73676 | 1.8% |
| Other values (128271) | 3069620 |
| Value | Count | Frequency (%) |
| 40.67833407 | 1 | < 0.1% |
| 40.69187865 | 1 | < 0.1% |
| 40.69263997 | 304 | |
| 40.69531906 | 1 | < 0.1% |
| 40.6970299 | 507 | |
| 40.69865054 | 607 | |
| 40.69967915 | 1 | < 0.1% |
| 40.70068073 | 1 | < 0.1% |
| 40.70362493 | 1 | < 0.1% |
| 40.70452571 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40.8066187 | 1 | < 0.1% |
| 40.8028376 | 1 | < 0.1% |
| 40.79953315 | 1 | < 0.1% |
| 40.79118803 | 1 | < 0.1% |
| 40.78903018 | 9 | |
| 40.78179272 | 1 | < 0.1% |
| 40.78096507 | 1 | < 0.1% |
| 40.77986812 | 2 | < 0.1% |
| 40.77917727 | 1 | < 0.1% |
| 40.77564173 | 1 | < 0.1% |
start_station_longitude
Real number (ℝ)
| Distinct | 136378 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -74.042824 |
| Minimum | -74.096937 |
|---|---|
| Maximum | -73.997279 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 4154739 |
| Negative (%) | 100.0% |
| Memory size | 63.4 MiB |
Quantile statistics
| Minimum | -74.096937 |
|---|---|
| 5-th percentile | -74.067104 |
| Q1 | -74.04879 |
| median | -74.042817 |
| Q3 | -74.033552 |
| 95-th percentile | -74.027781 |
| Maximum | -73.997279 |
| Range | 0.099658033 |
| Interquartile range (IQR) | 0.015238436 |
Descriptive statistics
| Standard deviation | 0.012030775 |
|---|---|
| Coefficient of variation (CV) | -0.00016248402 |
| Kurtosis | 0.52153601 |
| Mean | -74.042824 |
| Median Absolute Deviation (MAD) | 0.0081729438 |
| Skewness | -0.92486155 |
| Sum | -3.0762861 × 108 |
| Variance | 0.00014473956 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -74.04311746 | 238391 | 5.7% |
| -74.04424731 | 142834 | 3.4% |
| -74.0337589 | 119577 | 2.9% |
| -74.0321082 | 109393 | 2.6% |
| -74.04281706 | 90710 | 2.2% |
| -74.034234 | 83288 | 2.0% |
| -74.043845 | 82173 | 2.0% |
| -74.03805095 | 77973 | 1.9% |
| -74.0557013 | 74476 | 1.8% |
| -74.04630454 | 73676 | 1.8% |
| Other values (136368) | 3062248 |
| Value | Count | Frequency (%) |
| -74.0969366 | 507 | |
| -74.08896387 | 2 | < 0.1% |
| -74.0887723 | 689 | |
| -74.08801228 | 304 | |
| -74.08722293 | 1 | < 0.1% |
| -74.08706903 | 1 | < 0.1% |
| -74.0868541 | 1 | < 0.1% |
| -74.08684921 | 1 | < 0.1% |
| -74.08684228 | 1 | < 0.1% |
| -74.08682585 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| -73.99727857 | 1 | < 0.1% |
| -73.99793313 | 9 | |
| -73.99886102 | 1 | < 0.1% |
| -74.00098978 | 2 | < 0.1% |
| -74.00336778 | 1 | < 0.1% |
| -74.00455577 | 1 | < 0.1% |
| -74.00700725 | 1 | < 0.1% |
| -74.00907335 | 1 | < 0.1% |
| -74.01260012 | 4 | |
| -74.0140628 | 1 | < 0.1% |
end_station_id
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 2608 |
|---|---|
| Missing (%) | 0.1% |
| Memory size | 254.6 MiB |
end_station_name
Text
| Distinct | 586 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2608 |
| Missing (%) | 0.1% |
| Memory size | 324.5 MiB |
Length
| Max length | 55 |
|---|---|
| Median length | 40 |
| Mean length | 16.924165 |
| Min length | 4 |
Characters and Unicode
| Total characters | 70271349 |
|---|---|
| Distinct characters | 66 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 165 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | City Hall |
|---|---|
| 2nd row | Heights Elevator |
| 3rd row | Newark Ave |
| 4th row | Danforth Light Rail |
| 5th row | Hamilton Park |
| Value | Count | Frequency (%) |
| st | 2524756 | 17.1% |
| 1855311 | 12.5% | |
| path | 487486 | 3.3% |
| park | 469073 | 3.2% |
| ave | 467573 | 3.2% |
| grove | 350723 | 2.4% |
| hudson | 284030 | 1.9% |
| newport | 259493 | 1.8% |
| pl | 246014 | 1.7% |
| rail | 245556 | 1.7% |
| Other values (415) | 7611810 |
Most occurring characters
| Value | Count | Frequency (%) |
| 10649710 | 15.2% | |
| t | 5101326 | 7.3% |
| r | 4143604 | 5.9% |
| a | 4123322 | 5.9% |
| e | 3775432 | 5.4% |
| o | 3587533 | 5.1% |
| n | 3522114 | 5.0% |
| S | 3109347 | 4.4% |
| i | 2976355 | 4.2% |
| l | 2408860 | 3.4% |
| Other values (56) | 26873746 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 43033503 | |
| Uppercase Letter | 13245182 | 18.8% |
| Space Separator | 10649710 | 15.2% |
| Decimal Number | 1486988 | 2.1% |
| Other Punctuation | 1328776 | 1.9% |
| Dash Punctuation | 527163 | 0.8% |
| Close Punctuation | 13 | < 0.1% |
| Open Punctuation | 13 | < 0.1% |
| Connector Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 5101326 | |
| r | 4143604 | |
| a | 4123322 | |
| e | 3775432 | 8.8% |
| o | 3587533 | 8.3% |
| n | 3522114 | 8.2% |
| i | 2976355 | 6.9% |
| l | 2408860 | 5.6% |
| s | 1817937 | 4.2% |
| k | 1336023 | 3.1% |
| Other values (15) | 10240997 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 3109347 | |
| H | 1588366 | |
| P | 1537133 | |
| A | 1018401 | 7.7% |
| M | 691193 | 5.2% |
| C | 687070 | 5.2% |
| T | 682458 | 5.2% |
| G | 567973 | 4.3% |
| L | 529544 | 4.0% |
| W | 509125 | 3.8% |
| Other values (13) | 2324572 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 617125 | |
| 4 | 201283 | 13.5% |
| 6 | 182305 | 12.3% |
| 2 | 128816 | 8.7% |
| 5 | 79211 | 5.3% |
| 8 | 71700 | 4.8% |
| 9 | 64998 | 4.4% |
| 7 | 61398 | 4.1% |
| 3 | 54841 | 3.7% |
| 0 | 25311 | 1.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 1328166 | |
| ' | 596 | < 0.1% |
| \ | 14 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 10649710 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 527163 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 13 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 13 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 56278685 | |
| Common | 13992664 | 19.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 5101326 | 9.1% |
| r | 4143604 | 7.4% |
| a | 4123322 | 7.3% |
| e | 3775432 | 6.7% |
| o | 3587533 | 6.4% |
| n | 3522114 | 6.3% |
| S | 3109347 | 5.5% |
| i | 2976355 | 5.3% |
| l | 2408860 | 4.3% |
| s | 1817937 | 3.2% |
| Other values (38) | 21712855 |
Common
| Value | Count | Frequency (%) |
| 10649710 | ||
| & | 1328166 | 9.5% |
| 1 | 617125 | 4.4% |
| - | 527163 | 3.8% |
| 4 | 201283 | 1.4% |
| 6 | 182305 | 1.3% |
| 2 | 128816 | 0.9% |
| 5 | 79211 | 0.6% |
| 8 | 71700 | 0.5% |
| 9 | 64998 | 0.5% |
| Other values (8) | 142187 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 70271349 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 10649710 | 15.2% | |
| t | 5101326 | 7.3% |
| r | 4143604 | 5.9% |
| a | 4123322 | 5.9% |
| e | 3775432 | 5.4% |
| o | 3587533 | 5.1% |
| n | 3522114 | 5.0% |
| S | 3109347 | 4.4% |
| i | 2976355 | 4.2% |
| l | 2408860 | 3.4% |
| Other values (56) | 26873746 |
end_station_latitude
Real number (ℝ)
| Distinct | 683 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 40.72787 |
| Minimum | 40.64507 |
|---|---|
| Maximum | 40.832164 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 63.4 MiB |
Quantile statistics
| Minimum | 40.64507 |
|---|---|
| 5-th percentile | 40.712774 |
| Q1 | 40.719252 |
| median | 40.72534 |
| Q3 | 40.736068 |
| 95-th percentile | 40.749985 |
| Maximum | 40.832164 |
| Range | 0.187094 |
| Interquartile range (IQR) | 0.016815956 |
Descriptive statistics
| Standard deviation | 0.011485306 |
|---|---|
| Coefficient of variation (CV) | 0.00028200114 |
| Kurtosis | -0.60761009 |
| Mean | 40.72787 |
| Median Absolute Deviation (MAD) | 0.0076074254 |
| Skewness | 0.61049202 |
| Sum | 1.6921367 × 108 |
| Variance | 0.00013191224 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.71958612 | 297863 | 7.2% |
| 40.72759597 | 152564 | 3.7% |
| 40.7272235 | 136301 | 3.3% |
| 40.7287448 | 122024 | 2.9% |
| 40.71458404 | 99974 | 2.4% |
| 40.73606766 | 91852 | 2.2% |
| 40.7177325 | 91630 | 2.2% |
| 40.73698222 | 90033 | 2.2% |
| 40.7192517 | 88715 | 2.1% |
| 40.7112423 | 87852 | 2.1% |
| Other values (673) | 2895931 |
| Value | Count | Frequency (%) |
| 40.64507 | 1 | |
| 40.646377 | 1 | |
| 40.649292 | 1 | |
| 40.64958 | 1 | |
| 40.6630619 | 1 | |
| 40.6663181 | 1 | |
| 40.6679411 | 1 | |
| 40.66967 | 1 | |
| 40.67 | 1 | |
| 40.6704922 | 2 |
| Value | Count | Frequency (%) |
| 40.832164 | 1 | < 0.1% |
| 40.8120562 | 1 | < 0.1% |
| 40.8082 | 4 | |
| 40.8078316 | 1 | < 0.1% |
| 40.8067581 | 4 | |
| 40.805973 | 1 | < 0.1% |
| 40.804213 | 3 | |
| 40.802692 | 1 | < 0.1% |
| 40.801694 | 1 | < 0.1% |
| 40.8008363 | 1 | < 0.1% |
end_station_longitude
Real number (ℝ)
| Distinct | 682 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -74.042467 |
| Minimum | -74.11 |
|---|---|
| Maximum | -73.948603 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 4154739 |
| Negative (%) | 100.0% |
| Memory size | 63.4 MiB |
Quantile statistics
| Minimum | -74.11 |
|---|---|
| 5-th percentile | -74.066611 |
| Q1 | -74.047727 |
| median | -74.042817 |
| Q3 | -74.033552 |
| 95-th percentile | -74.027781 |
| Maximum | -73.948603 |
| Range | 0.16139706 |
| Interquartile range (IQR) | 0.014174725 |
Descriptive statistics
| Standard deviation | 0.011955561 |
|---|---|
| Coefficient of variation (CV) | -0.00016146897 |
| Kurtosis | 0.96656422 |
| Mean | -74.042467 |
| Median Absolute Deviation (MAD) | 0.0078393438 |
| Skewness | -0.9367918 |
| Sum | -3.0762713 × 108 |
| Variance | 0.00014293543 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -74.04311746 | 297863 | 7.2% |
| -74.04424731 | 152564 | 3.7% |
| -74.0337589 | 136301 | 3.3% |
| -74.0321082 | 122024 | 2.9% |
| -74.04281706 | 99974 | 2.4% |
| -74.043845 | 92074 | 2.2% |
| -74.02912706 | 91852 | 2.2% |
| -74.02778059 | 90033 | 2.2% |
| -74.034234 | 89193 | 2.1% |
| -74.0557013 | 87852 | 2.1% |
| Other values (672) | 2895009 |
| Value | Count | Frequency (%) |
| -74.11 | 3 | < 0.1% |
| -74.1 | 9 | < 0.1% |
| -74.0969366 | 553 | < 0.1% |
| -74.09 | 11 | < 0.1% |
| -74.08896387 | 2 | < 0.1% |
| -74.0887723 | 993 | < 0.1% |
| -74.08801228 | 355 | < 0.1% |
| -74.086701 | 23 | < 0.1% |
| -74.08670068 | 3125 | |
| -74.08593088 | 108 | < 0.1% |
| Value | Count | Frequency (%) |
| -73.94860294 | 1 | < 0.1% |
| -73.9488 | 1 | < 0.1% |
| -73.9488134 | 1 | < 0.1% |
| -73.949373 | 1 | < 0.1% |
| -73.94963041 | 1 | < 0.1% |
| -73.949702 | 1 | < 0.1% |
| -73.9503 | 2 | |
| -73.950503 | 2 | |
| -73.95068615 | 1 | < 0.1% |
| -73.95095259 | 3 |
bike_id
Real number (ℝ)
MISSING 
| Distinct | 3110 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 2483972 |
| Missing (%) | 59.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30498.736 |
| Minimum | 14529 |
|---|---|
| Maximum | 49985 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 63.4 MiB |
Quantile statistics
| Minimum | 14529 |
|---|---|
| 5-th percentile | 24475 |
| Q1 | 26219 |
| median | 29299 |
| Q3 | 31695 |
| 95-th percentile | 44212 |
| Maximum | 49985 |
| Range | 35456 |
| Interquartile range (IQR) | 5476 |
Descriptive statistics
| Standard deviation | 6240.8602 |
|---|---|
| Coefficient of variation (CV) | 0.20462684 |
| Kurtosis | 0.39520877 |
| Mean | 30498.736 |
| Median Absolute Deviation (MAD) | 3049 |
| Skewness | 1.1924102 |
| Sum | 5.0956282 × 1010 |
| Variance | 38948336 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 26159 | 2688 | 0.1% |
| 26260 | 2677 | 0.1% |
| 26161 | 2659 | 0.1% |
| 26236 | 2658 | 0.1% |
| 26170 | 2653 | 0.1% |
| 26306 | 2647 | 0.1% |
| 26431 | 2629 | 0.1% |
| 26192 | 2620 | 0.1% |
| 26213 | 2617 | 0.1% |
| 26286 | 2605 | 0.1% |
| Other values (3100) | 1644314 | |
| (Missing) | 2483972 |
| Value | Count | Frequency (%) |
| 14529 | 3 | < 0.1% |
| 14531 | 43 | < 0.1% |
| 14536 | 19 | < 0.1% |
| 14552 | 10 | < 0.1% |
| 14556 | 34 | < 0.1% |
| 14578 | 3 | < 0.1% |
| 14585 | 100 | |
| 14598 | 57 | < 0.1% |
| 14607 | 175 | |
| 14632 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 49985 | 5 | < 0.1% |
| 49734 | 3 | < 0.1% |
| 49527 | 14 | < 0.1% |
| 49081 | 19 | < 0.1% |
| 49058 | 5 | < 0.1% |
| 48932 | 94 | |
| 48930 | 63 | |
| 48929 | 60 | |
| 48924 | 92 | |
| 48923 | 66 |
user_type
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 487 |
| Missing (%) | < 0.1% |
| Memory size | 261.5 MiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 4154252 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 3162902 | |
| 0 | 991350 | 23.9% |
| (Missing) | 487 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 3162902 | |
| 0 | 991350 | 23.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 3162902 | |
| 0 | 991350 | 23.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4154252 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 3162902 | |
| 0 | 991350 | 23.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4154252 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 3162902 | |
| 0 | 991350 | 23.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4154252 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 3162902 | |
| 0 | 991350 | 23.9% |
birth_year
Real number (ℝ)
MISSING 
| Distinct | 81 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2524704 |
| Missing (%) | 60.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1980.5907 |
| Minimum | 1887 |
|---|---|
| Maximum | 2004 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 63.4 MiB |
Quantile statistics
| Minimum | 1887 |
|---|---|
| 5-th percentile | 1960 |
| Q1 | 1974 |
| median | 1983 |
| Q3 | 1988 |
| 95-th percentile | 1994 |
| Maximum | 2004 |
| Range | 117 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 10.336333 |
|---|---|
| Coefficient of variation (CV) | 0.0052188135 |
| Kurtosis | 1.4461822 |
| Mean | 1980.5907 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.89322602 |
| Sum | 3.2284321 × 109 |
| Variance | 106.83979 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1969 | 103535 | 2.5% |
| 1989 | 83871 | 2.0% |
| 1986 | 82971 | 2.0% |
| 1988 | 81748 | 2.0% |
| 1987 | 75175 | 1.8% |
| 1984 | 72459 | 1.7% |
| 1990 | 71014 | 1.7% |
| 1983 | 66513 | 1.6% |
| 1985 | 64494 | 1.6% |
| 1981 | 62911 | 1.5% |
| Other values (71) | 865344 | 20.8% |
| (Missing) | 2524704 |
| Value | Count | Frequency (%) |
| 1887 | 70 | < 0.1% |
| 1888 | 260 | |
| 1889 | 4 | < 0.1% |
| 1900 | 65 | < 0.1% |
| 1901 | 1 | < 0.1% |
| 1904 | 19 | < 0.1% |
| 1918 | 2 | < 0.1% |
| 1920 | 1 | < 0.1% |
| 1923 | 3 | < 0.1% |
| 1930 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 2004 | 23 | < 0.1% |
| 2003 | 276 | < 0.1% |
| 2002 | 622 | < 0.1% |
| 2001 | 1405 | < 0.1% |
| 2000 | 2649 | 0.1% |
| 1999 | 2737 | 0.1% |
| 1998 | 5699 | 0.1% |
| 1997 | 7657 | 0.2% |
| 1996 | 16328 | |
| 1995 | 20409 |
gender
Categorical
MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2483972 |
| Missing (%) | 59.8% |
| Memory size | 260.0 MiB |
| 1.0 | |
|---|---|
| 2.0 | |
| 0.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 5012301 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 1162335 | |
| 2.0 | 371323 | 8.9% |
| 0.0 | 137109 | 3.3% |
| (Missing) | 2483972 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 1162335 | |
| 2.0 | 371323 | 22.2% |
| 0.0 | 137109 | 8.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1807876 | |
| . | 1670767 | |
| 1 | 1162335 | |
| 2 | 371323 | 7.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3341534 | |
| Other Punctuation | 1670767 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1807876 | |
| 1 | 1162335 | |
| 2 | 371323 | 11.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 1670767 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5012301 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1807876 | |
| . | 1670767 | |
| 1 | 1162335 | |
| 2 | 371323 | 7.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5012301 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1807876 | |
| . | 1670767 | |
| 1 | 1162335 | |
| 2 | 371323 | 7.4% |
ride_id
Text
MISSING 
| Distinct | 2483972 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 1670767 |
| Missing (%) | 40.2% |
| Memory size | 255.6 MiB |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 39743552 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2483972 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 58EEE2950FFE01CE |
|---|---|
| 2nd row | 1429D912C16EEE59 |
| 3rd row | FE9C5B74167CBCCD |
| 4th row | B88D37626F000BBA |
| 5th row | 2A75E47239553321 |
| Value | Count | Frequency (%) |
| 58eee2950ffe01ce | 1 | < 0.1% |
| fe9c5b74167cbccd | 1 | < 0.1% |
| b88d37626f000bba | 1 | < 0.1% |
| 9055e11e8d414319 | 1 | < 0.1% |
| 2a99fcafc6b1c7ce | 1 | < 0.1% |
| b31e3625915a88e1 | 1 | < 0.1% |
| e0b99a4aaca77034 | 1 | < 0.1% |
| bd52c7872af620e6 | 1 | < 0.1% |
| 20bd42adad2ca6a0 | 1 | < 0.1% |
| 23467b6f12bca65b | 1 | < 0.1% |
| Other values (2483962) | 2483962 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 2485763 | 6.3% |
| 8 | 2485669 | 6.3% |
| 2 | 2485302 | 6.3% |
| 5 | 2485292 | 6.3% |
| A | 2485246 | 6.3% |
| D | 2484400 | 6.3% |
| 1 | 2484339 | 6.3% |
| F | 2484106 | 6.3% |
| E | 2483925 | 6.2% |
| 7 | 2483842 | 6.2% |
| Other values (6) | 14895668 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 24839670 | |
| Uppercase Letter | 14903882 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 2485763 | |
| 8 | 2485669 | |
| 2 | 2485302 | |
| 5 | 2485292 | |
| 1 | 2484339 | |
| 7 | 2483842 | |
| 9 | 2482906 | |
| 4 | 2482782 | |
| 0 | 2481904 | |
| 6 | 2481871 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2485246 | |
| D | 2484400 | |
| F | 2484106 | |
| E | 2483925 | |
| B | 2483794 | |
| C | 2482411 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 24839670 | |
| Latin | 14903882 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 2485763 | |
| 8 | 2485669 | |
| 2 | 2485302 | |
| 5 | 2485292 | |
| 1 | 2484339 | |
| 7 | 2483842 | |
| 9 | 2482906 | |
| 4 | 2482782 | |
| 0 | 2481904 | |
| 6 | 2481871 |
Latin
| Value | Count | Frequency (%) |
| A | 2485246 | |
| D | 2484400 | |
| F | 2484106 | |
| E | 2483925 | |
| B | 2483794 | |
| C | 2482411 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 39743552 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 2485763 | 6.3% |
| 8 | 2485669 | 6.3% |
| 2 | 2485302 | 6.3% |
| 5 | 2485292 | 6.3% |
| A | 2485246 | 6.3% |
| D | 2484400 | 6.3% |
| 1 | 2484339 | 6.3% |
| F | 2484106 | 6.3% |
| E | 2483925 | 6.2% |
| 7 | 2483842 | 6.2% |
| Other values (6) | 14895668 |
rideable_type
Categorical
MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1670767 |
| Missing (%) | 40.2% |
| Memory size | 284.7 MiB |
| classic_bike | |
|---|---|
| electric_bike | |
| docked_bike | 136452 |
Length
| Max length | 13 |
|---|---|
| Median length | 12 |
| Mean length | 12.154731 |
| Min length | 11 |
Characters and Unicode
| Total characters | 30192011 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | docked_bike |
|---|---|
| 2nd row | docked_bike |
| 3rd row | docked_bike |
| 4th row | docked_bike |
| 5th row | docked_bike |
Common Values
| Value | Count | Frequency (%) |
| classic_bike | 1826721 | |
| electric_bike | 520799 | 12.5% |
| docked_bike | 136452 | 3.3% |
| (Missing) | 1670767 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| classic_bike | 1826721 | |
| electric_bike | 520799 | 21.0% |
| docked_bike | 136452 | 5.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| c | 4831492 | |
| i | 4831492 | |
| e | 3662022 | |
| s | 3653442 | |
| k | 2620424 | |
| b | 2483972 | |
| _ | 2483972 | |
| l | 2347520 | |
| a | 1826721 | 6.1% |
| t | 520799 | 1.7% |
| Other values (3) | 930155 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 27708039 | |
| Connector Punctuation | 2483972 | 8.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| c | 4831492 | |
| i | 4831492 | |
| e | 3662022 | |
| s | 3653442 | |
| k | 2620424 | |
| b | 2483972 | |
| l | 2347520 | |
| a | 1826721 | 6.6% |
| t | 520799 | 1.9% |
| r | 520799 | 1.9% |
| Other values (2) | 409356 | 1.5% |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 2483972 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 27708039 | |
| Common | 2483972 | 8.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| c | 4831492 | |
| i | 4831492 | |
| e | 3662022 | |
| s | 3653442 | |
| k | 2620424 | |
| b | 2483972 | |
| l | 2347520 | |
| a | 1826721 | 6.6% |
| t | 520799 | 1.9% |
| r | 520799 | 1.9% |
| Other values (2) | 409356 | 1.5% |
Common
| Value | Count | Frequency (%) |
| _ | 2483972 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 30192011 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| c | 4831492 | |
| i | 4831492 | |
| e | 3662022 | |
| s | 3653442 | |
| k | 2620424 | |
| b | 2483972 | |
| _ | 2483972 | |
| l | 2347520 | |
| a | 1826721 | 6.1% |
| t | 520799 | 1.7% |
| Other values (3) | 930155 | 3.1% |
| trip_duration | start_time | stop_time | start_station_id | start_station_name | start_station_latitude | start_station_longitude | end_station_id | end_station_name | end_station_latitude | end_station_longitude | bike_id | user_type | birth_year | gender | ride_id | rideable_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 148.0 | 2017-01-01 00:21:32 | 2017-01-01 00:24:01 | 3276 | Marin Light Rail | 40.714584 | -74.042817 | 3185 | City Hall | 40.717732 | -74.043845 | 24575.0 | 1 | 1983.0 | 1.0 | NaN | NaN |
| 1 | 1283.0 | 2017-01-01 00:24:35 | 2017-01-01 00:45:58 | 3183 | Exchange Place | 40.716247 | -74.033459 | 3198 | Heights Elevator | 40.748716 | -74.040443 | 24723.0 | 1 | 1978.0 | 1.0 | NaN | NaN |
| 2 | 372.0 | 2017-01-01 00:38:19 | 2017-01-01 00:44:31 | 3183 | Exchange Place | 40.716247 | -74.033459 | 3211 | Newark Ave | 40.721525 | -74.046305 | 24620.0 | 1 | 1989.0 | 1.0 | NaN | NaN |
| 3 | 1513.0 | 2017-01-01 00:38:37 | 2017-01-01 01:03:50 | 3194 | McGinley Square | 40.725340 | -74.067622 | 3271 | Danforth Light Rail | 40.692640 | -74.088012 | 24668.0 | 1 | 1961.0 | 1.0 | NaN | NaN |
| 4 | 639.0 | 2017-01-01 01:47:52 | 2017-01-01 01:58:31 | 3183 | Exchange Place | 40.716247 | -74.033459 | 3203 | Hamilton Park | 40.727596 | -74.044247 | 26167.0 | 1 | 1993.0 | 1.0 | NaN | NaN |
| 5 | 258.0 | 2017-01-01 01:56:29 | 2017-01-01 02:00:48 | 3186 | Grove St PATH | 40.719586 | -74.043117 | 3270 | Jersey & 6th St | 40.725289 | -74.045572 | 24604.0 | 1 | 1970.0 | 1.0 | NaN | NaN |
| 6 | 663.0 | 2017-01-01 02:12:34 | 2017-01-01 02:23:38 | 3270 | Jersey & 6th St | 40.725289 | -74.045572 | 3206 | Hilltop | 40.731169 | -74.057574 | 24641.0 | 1 | 1978.0 | 1.0 | NaN | NaN |
| 7 | 567.0 | 2017-01-01 02:15:52 | 2017-01-01 02:25:20 | 3192 | Liberty Light Rail | 40.711242 | -74.055701 | 3213 | Van Vorst Park | 40.718489 | -74.047727 | 24513.0 | 1 | 1970.0 | 1.0 | NaN | NaN |
| 8 | 551.0 | 2017-01-01 02:16:03 | 2017-01-01 02:25:15 | 3192 | Liberty Light Rail | 40.711242 | -74.055701 | 3213 | Van Vorst Park | 40.718489 | -74.047727 | 24463.0 | 1 | 1967.0 | 2.0 | NaN | NaN |
| 9 | 573.0 | 2017-01-01 02:22:17 | 2017-01-01 02:31:50 | 3212 | Christ Hospital | 40.734786 | -74.050444 | 3225 | Baldwin at Montgomery | 40.723659 | -74.064194 | 24486.0 | 1 | 1984.0 | 1.0 | NaN | NaN |
| trip_duration | start_time | stop_time | start_station_id | start_station_name | start_station_latitude | start_station_longitude | end_station_id | end_station_name | end_station_latitude | end_station_longitude | bike_id | user_type | birth_year | gender | ride_id | rideable_type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4207967 | 76.0 | NaT | NaT | 3185 | City Hall | 40.717732 | -74.043845 | 3185 | City Hall | 40.717732 | -74.043845 | 44737.0 | 1 | 1976.0 | 1.0 | NaN | NaN |
| 4207968 | 305.0 | NaT | NaT | 3186 | Grove St PATH | 40.719586 | -74.043117 | 3203 | Hamilton Park | 40.727596 | -74.044247 | 42213.0 | 1 | 1996.0 | 1.0 | NaN | NaN |
| 4207969 | 99.0 | NaT | NaT | 3185 | City Hall | 40.717732 | -74.043845 | 3185 | City Hall | 40.717732 | -74.043845 | 44347.0 | 1 | 1976.0 | 1.0 | NaN | NaN |
| 4207970 | 492.0 | NaT | NaT | 3195 | Sip Ave | 40.730897 | -74.063913 | 3225 | Baldwin at Montgomery | 40.723659 | -74.064194 | 46598.0 | 0 | 1998.0 | 1.0 | NaN | NaN |
| 4207971 | 715.0 | NaT | NaT | 3185 | City Hall | 40.717732 | -74.043845 | 3269 | Brunswick & 6th | 40.726012 | -74.050389 | 44737.0 | 1 | 1976.0 | 1.0 | NaN | NaN |
| 4207972 | 270.0 | NaT | NaT | 3207 | Oakland Ave | 40.737604 | -74.052478 | 3640 | Journal Square | 40.733670 | -74.062500 | 44744.0 | 1 | 1963.0 | 2.0 | NaN | NaN |
| 4207973 | 400.0 | NaT | NaT | 3209 | Brunswick St | 40.724176 | -74.050656 | 3209 | Brunswick St | 40.724176 | -74.050656 | 45345.0 | 1 | 1984.0 | 1.0 | NaN | NaN |
| 4207974 | 206.0 | NaT | NaT | 3195 | Sip Ave | 40.730897 | -74.063913 | 3194 | McGinley Square | 40.725340 | -74.067622 | 47019.0 | 1 | 1993.0 | 1.0 | NaN | NaN |
| 4207975 | 216.0 | NaT | NaT | 3195 | Sip Ave | 40.730897 | -74.063913 | 3225 | Baldwin at Montgomery | 40.723659 | -74.064194 | 42191.0 | 1 | 1966.0 | 1.0 | NaN | NaN |
| 4207976 | 418.0 | NaT | NaT | 3267 | Morris Canal | 40.712419 | -74.038526 | 3186 | Grove St PATH | 40.719586 | -74.043117 | 47255.0 | 1 | 1991.0 | 1.0 | NaN | NaN |
Most frequently occurring
| trip_duration | start_time | stop_time | start_station_name | start_station_latitude | start_station_longitude | end_station_name | end_station_latitude | end_station_longitude | bike_id | user_type | birth_year | gender | ride_id | rideable_type | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 834 | 166.0 | NaT | NaT | Monmouth and 6th | 40.725685 | -74.048790 | Manila & 1st | 40.721651 | -74.042884 | 29555.0 | 1 | 1993.0 | 1.0 | NaN | NaN | 3 |
| 2229 | 247.0 | NaT | NaT | Dey St | 40.737711 | -74.066921 | 5 Corners Library | 40.734961 | -74.059503 | 45350.0 | 1 | 1978.0 | 1.0 | NaN | NaN | 3 |
| 7306 | 601.0 | NaT | NaT | Newport Pkwy | 40.728745 | -74.032108 | Essex Light Rail | 40.712774 | -74.036486 | 42178.0 | 1 | 1980.0 | 1.0 | NaN | NaN | 3 |
| 0 | 61.0 | NaT | NaT | Brunswick & 6th | 40.726012 | -74.050389 | Brunswick St | 40.724176 | -74.050656 | 33887.0 | 1 | 1987.0 | 1.0 | NaN | NaN | 2 |
| 1 | 61.0 | NaT | NaT | Sip Ave | 40.730897 | -74.063913 | Sip Ave | 40.730897 | -74.063913 | 42535.0 | 1 | 1977.0 | 2.0 | NaN | NaN | 2 |
| 2 | 62.0 | NaT | NaT | City Hall | 40.717732 | -74.043845 | City Hall | 40.717732 | -74.043845 | 33859.0 | 1 | 1972.0 | 1.0 | NaN | NaN | 2 |
| 3 | 62.0 | NaT | NaT | Jersey & 6th St | 40.725289 | -74.045572 | Jersey & 3rd | 40.723332 | -74.045953 | 33859.0 | 1 | 1977.0 | 1.0 | NaN | NaN | 2 |
| 4 | 62.0 | NaT | NaT | Warren St | 40.721124 | -74.038051 | Warren St | 40.721124 | -74.038051 | 42195.0 | 1 | 1970.0 | 2.0 | NaN | NaN | 2 |
| 5 | 63.0 | NaT | NaT | Grove St PATH | 40.719586 | -74.043117 | City Hall | 40.717732 | -74.043845 | 29588.0 | 1 | 1987.0 | 1.0 | NaN | NaN | 2 |
| 6 | 63.0 | NaT | NaT | Newport Pkwy | 40.728745 | -74.032108 | Newport Pkwy | 40.728745 | -74.032108 | 42460.0 | 1 | 1986.0 | 1.0 | NaN | NaN | 2 |